for var in area claim_info cv_src dd_table mort_10_13 policy_acuary policy_benefit policy_client \
policy_surrender pre_add_exp_ratio prem_cv_real prem_std_real rsv_src; do
  /export/server/sqoop/bin/sqoop \
    import \
    --connect jdbc:mysql://192.168.88.100:3306/insurance \
    --username root \
    --password 123456 \
    --table $var \
    --hive-import \
    --hive-overwrite \
    --hive-table ods.$var \
    --fields-terminated-by '\t' \
    --delete-target-dir \
    --direct \
    --m 1
done
